// 客户类别
const {DataTypes, db } = require("../db");
db.define('contactCat', {
id: {type: DataTypes.INTEGER, primaryKey: true, autoIncrement: true,comment:'表自增ID'},
tenantId:{type: DataTypes.INTEGER,comment:''}, 
name:{type: DataTypes.STRING(20),comment:''}, 
code:{type: DataTypes.STRING(255),comment:''}, 
pinYin:{type: DataTypes.STRING(255),defaultValue:(''),comment:''}, 
pid:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
sort:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
cby:{type: DataTypes.INTEGER,comment:''}, 
ctime:{type: DataTypes.STRING(20),comment:''}, 
isDel:{type: DataTypes.INTEGER,defaultValue:0,comment:''}, 
printTitle:{type: DataTypes.STRING(255),comment:''},
printCodeBar:{type: DataTypes.INTEGER,defaultValue:0,comment:''},
printPhone:{type: DataTypes.STRING(255),comment:'票据正文打印电话及其它内容'}, 

}, {
    tableName: 'contact_cat',
    timestamps: false,
    comment: '客户类别',
    
});